/**
 * @description GoodsPhoto 商品信息表
 * @author LI
 */

const seq = require('../sequelize')
const { STRING, INTEGER } =require('../types')

// GoodsInfos GoodsInfo 写入到数据库时为 GoodsInfos
const GoodsInfo = seq.define('goodsInfo', {
  goodType: {
    type: STRING,
    allowNull: false,
    comment: '商品类型，所属的分类'
  },
  goodSn: {
    type: STRING,
    allowNull: false,
    comment: '商品货号 序列号'
  },
  goodName: {
    type: STRING,
    allowNull: false,
    comment: '商品名称'
  },
  goodImg: {
    type: STRING,
    allowNull: false,
    comment: '商品图片/视频图片'
  },
  goodVideo: {
    type: STRING,
    comment: '商品视频'
  },
  goodSort: {
    type: INTEGER,
    comment: '根据商品排序'
  },
  remark: {
    type: STRING,
    comment: '要求，备注'
  },
  reserve: {
    type: STRING,
    comment: '保留字段'
  }
},
{
  comment: '商品信息表',
})

module.exports = GoodsInfo
